<?php

/* @auther wf
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/

class SmallProblem {

	static function _getquestions($subject_id){
		$data = array();
		if (!empty($subject_id)){
			$sql = 'SELECT * FROM "{{question_type}}" WHERE "is_del" = 0 AND "subject_id" ='.$subject_id;
			$date = Yii::app()->db->createCommand($sql)->queryAll();
			foreach ($date as $k=>$v){
				$data[$v['question_id']]=$v['question_name'];
			}
		}
		return $data;
	}
	
	static function _getQuestionInfo($type_id){
		$name = array();
		
		if(!empty($type_id)){
			$sql = 'SELECT * FROM "{{question_type}}" WHERE "question_id" = :qid';
			$result = Yii::app()->db->createcommand($sql);
			$result->bindParam(':qid',$type_id,PDO::PARAM_STR);
			$data = $result->queryRow();
			if ($data){
				$name = $data['question_name'];
			}
		}
		return $name;
	}
	
	static function _getquestionsssss($subject){
		$subjectpy = SmallProblem::pinyin($subject);
		$data = array(
		'yw'=>array(
		'1'=>'客观题',
		'2'=>'主观题',
		'3'=>'作文',
		),
		'sx'=>array(
		'1'=>'客观题',
		'2'=>'主观题',
		'3'=>'填空题',
		'4'=>'解答题',
		),
		'yy'=>array(
		'1'=>'客观题',
		'2'=>'主观题',
		'3'=>'作文',
		),
		'wl'=>array(
		'1'=>'客观题',
		'2'=>'主观题',
		),
		'hx'=>array(
		'1'=>'客观题',
		'2'=>'主观题',
		),
		'sw'=>array(
		'1'=>'客观题',
		'2'=>'主观题',
		),
		'ls'=>array(
		'1'=>'客观题',
		'2'=>'主观题',
		),
		'zz'=>array(
		'1'=>'客观题',
		'2'=>'主观题',
		),
		'dl'=>array(
		'1'=>'客观题',
		'2'=>'主观题',
		),
		);
		$data[$subjectpy] = isset($data[$subjectpy]) ? $data[$subjectpy] :'';
		return $data[$subjectpy];
	}
	static function getfirstchar($s0){
		$firstchar_ord=ord(strtoupper($s0{0}));
		if (($firstchar_ord>=65 and $firstchar_ord<=91)or($firstchar_ord>=48 and $firstchar_ord<=57)) return $s0{0};
		$s=$s0;
		$asc=ord($s{0})*256+ord($s{1})-65536;
		if($asc>=-20319 and $asc<=-20284)return "a";
		if($asc>=-20283 and $asc<=-19776)return "b";
		if($asc>=-19775 and $asc<=-19219)return "c";
		if($asc>=-19218 and $asc<=-18711)return "d";
		if($asc>=-18710 and $asc<=-18527)return "e";
		if($asc>=-18526 and $asc<=-18240)return "f";
		if($asc>=-18239 and $asc<=-17923)return "g";
		if($asc>=-17922 and $asc<=-17418)return "h";
		if($asc>=-17417 and $asc<=-16475)return "j";
		if($asc>=-16474 and $asc<=-16213)return "k";
		if($asc>=-16212 and $asc<=-15641)return "l";
		if($asc>=-15640 and $asc<=-15166)return "m";
		if($asc>=-15165 and $asc<=-14923)return "n";
		if($asc>=-14922 and $asc<=-14915)return "o";
		if($asc>=-14914 and $asc<=-14631)return "p";
		if($asc>=-14630 and $asc<=-14150)return "q";
		if($asc>=-14149 and $asc<=-14091)return "r";
		if($asc>=-14090 and $asc<=-13319)return "s";
		if($asc>=-13318 and $asc<=-12839)return "t";
		if($asc>=-12838 and $asc<=-12557)return "w";
		if($asc>=-12556 and $asc<=-11848)return "x";
		if($asc>=-11847 and $asc<=-11056)return "y";
		if($asc>=-11055 and $asc<=-10247)return "z";
		return null;
	}
	static function pinyin($zh){
		$ret = "";
		$s1 = iconv("UTF-8","gb2312", $zh);
		$s2 = iconv("gb2312","UTF-8", $s1);
		if($s2 == $zh){$zh = $s1;}
		for($i = 0; $i < strlen($zh); $i++){
			$s1 = substr($zh,$i,1);
			$p = ord($s1);
			if($p > 160){
				$s2 = substr($zh,$i++,2);
				$ret .= SmallProblem::getfirstchar($s2);
			}else{
				$ret .= $s1;
			}
		}
		return $ret;
	}
	static function _getquestion_num($where=''){
		$sql = 'SELECT * FROM "{{teacher_num}}" WHERE 1=1 '.$where;
		$data = Yii::app()->db->createCommand($sql)->queryAll();
		return $data;
	}
}

?>
